import pandas as pd
import numpy as np



df = pd.read_csv('../CSV/vpnlog09-15_data_extract/vpnlog20201109.csv')
df.dropna(subset=['userName'], inplace=True)
df.dropna(subset=['clientInfo_location_ip.ip'], inplace=True)
df.dropna(subset=['clientInfo_vip'], inplace=True)
df.dropna(subset=['rcip'], inplace=True)
df.dropna(subset=['location_country_name'], inplace=True)
df.dropna(subset=['client_location_region_name'], inplace=True)
df.dropna(subset=['client_location_city_name'], inplace=True)

df.to_csv('../CSV/sort-output.csv',mode='a+',index=False)
